<?php

use yii\db\Migration;

class m240417_014729_diandi_place_list extends Migration
{
    public function up()
    {
        /* 取消外键约束 */
        $this->execute('SET foreign_key_checks = 0');
        
        /* 创建表 */
        $this->createTable('{{%diandi_place_list}}', [
            'id' => "int(11) NOT NULL AUTO_INCREMENT",
            'bloc_id' => "int(11) NULL DEFAULT '0' COMMENT '公司ID'",
            'store_id' => "int(11) NULL DEFAULT '0' COMMENT '商家ID'",
            'name' => "varchar(255) NULL DEFAULT '' COMMENT '酒店名称'",
            'lng' => "decimal(10,2) NULL COMMENT '经度'",
            'lat' => "decimal(10,2) NULL COMMENT '维度'",
            'is_show' => "int(11) NULL COMMENT '是否公开'",
            'address_show' => "int(11) NULL COMMENT '是否公开地址'",
            'type' => "int(11) NULL COMMENT '房源类型'",
            'address' => "varchar(255) NULL DEFAULT '' COMMENT '具体地址'",
            'province' => "int(11) NULL DEFAULT '0' COMMENT '省份'",
            'city' => "int(11) NULL DEFAULT '0' COMMENT '城市'",
            'county' => "int(11) NULL DEFAULT '0' COMMENT '区县'",
            'apartment_type' => "int(11) NULL DEFAULT '0'",
            'roomcount' => "int(11) NULL DEFAULT '0' COMMENT '房间总量'",
            'status' => "int(11) NULL DEFAULT '0' COMMENT '酒店状态'",
            'phone' => "varchar(255) NULL DEFAULT '' COMMENT '联系电话'",
            'mail' => "varchar(255) NULL DEFAULT '' COMMENT '联系邮箱'",
            'thumb' => "varchar(255) NULL DEFAULT '' COMMENT '酒店图片'",
            'description' => "text NULL COMMENT '酒店简介'",
            'content' => "text NULL COMMENT '酒店介绍'",
            'traffic' => "text NULL COMMENT '周边交通'",
            'thumbs' => "text NULL COMMENT '酒店相册'",
            'sales' => "text NULL",
            'displayorder' => "int(11) NULL DEFAULT '0' COMMENT '排序'",
            'comment_num' => "int(11) NULL DEFAULT '0' COMMENT '评价数量'",
            'comment_start' => "decimal(11,2) NULL COMMENT '评价星级'",
            'level' => "int(11) NULL DEFAULT '0' COMMENT '酒店星级'",
            'device' => "text NULL COMMENT '服务设施'",
            'brandid' => "int(11) NULL DEFAULT '0' COMMENT '所属品牌'",
            'language' => "tinyint(4) NOT NULL DEFAULT '0' COMMENT '语言类型标志/默认中文0'",
            'landlord_id' => "int(11) NULL DEFAULT '0' COMMENT '房东ID'",
            'price' => "decimal(10,2) NULL COMMENT '单价'",
            'lease_type' => "int(11) NULL COMMENT '1整租 2合租'",
            'time_length' => "int(11) NULL COMMENT '租约类型：时间，月，天，年'",
            'create_time' => "datetime NULL",
            'update_time' => "datetime NULL",
            'PRIMARY KEY (`id`)'
        ], "ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='酒店主表'");
        
        /* 索引设置 */
        
        
        /* 表数据 */
        $this->insert('{{%diandi_place_list}}',['id'=>'106','bloc_id'=>'93','store_id'=>'2','name'=>'昆仑巢','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'5','address'=>'昆仑巢','province'=>'1','city'=>'2','county'=>'3','apartment_type'=>NULL,'roomcount'=>'15','status'=>'1','phone'=>'','mail'=>'12','thumb'=>'202311/19/bec2edc9-d90b-3be5-80ac-059292dbe4ff.jpg','description'=>'','content'=>'','traffic'=>'12','thumbs'=>'a:1:{i:0;s:50:"202311/19/9610290c-8d8e-3e58-abdf-8ab2d5606a36.jpg";}','sales'=>'55','displayorder'=>'12','comment_num'=>'0','comment_start'=>NULL,'level'=>'12','device'=>'12','brandid'=>'23','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2023-11-19 13:59:35','update_time'=>'2024-02-03 01:36:14']);
        $this->insert('{{%diandi_place_list}}',['id'=>'107','bloc_id'=>'91','store_id'=>'289','name'=>'楼栋1','lng'=>NULL,'lat'=>NULL,'is_show'=>'0','address_show'=>'0','type'=>'22','address'=>'','province'=>NULL,'city'=>NULL,'county'=>NULL,'apartment_type'=>'0','roomcount'=>NULL,'status'=>'0','phone'=>NULL,'mail'=>NULL,'thumb'=>NULL,'description'=>NULL,'content'=>NULL,'traffic'=>NULL,'thumbs'=>NULL,'sales'=>NULL,'displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'10','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-01-15 17:17:01','update_time'=>'2024-01-15 17:17:01']);
        $this->insert('{{%diandi_place_list}}',['id'=>'108','bloc_id'=>'91','store_id'=>'290','name'=>'酒店1','lng'=>NULL,'lat'=>NULL,'is_show'=>'0','address_show'=>'0','type'=>'15','address'=>'','province'=>NULL,'city'=>NULL,'county'=>NULL,'apartment_type'=>'0','roomcount'=>NULL,'status'=>'0','phone'=>NULL,'mail'=>NULL,'thumb'=>NULL,'description'=>NULL,'content'=>NULL,'traffic'=>NULL,'thumbs'=>NULL,'sales'=>NULL,'displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'10','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-01-15 17:17:36','update_time'=>'2024-01-15 17:17:36']);
        $this->insert('{{%diandi_place_list}}',['id'=>'109','bloc_id'=>'91','store_id'=>'293','name'=>'新的酒店测试','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'15','address'=>'','province'=>'0','city'=>'0','county'=>'0','apartment_type'=>NULL,'roomcount'=>'0','status'=>'0','phone'=>'','mail'=>'','thumb'=>'','description'=>'','content'=>'','traffic'=>'','thumbs'=>'a:0:{}','sales'=>'','displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>'','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-01-30 16:58:01','update_time'=>'2024-01-30 17:58:35']);
        $this->insert('{{%diandi_place_list}}',['id'=>'110','bloc_id'=>'103','store_id'=>'295','name'=>'方正','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'23','address'=>'厦门市','province'=>'0','city'=>'0','county'=>'0','apartment_type'=>NULL,'roomcount'=>'1','status'=>'1','phone'=>'','mail'=>'1','thumb'=>'202402/01/94fc121d-4daa-3216-bc3b-20c154eb0570.jpg','description'=>NULL,'content'=>NULL,'traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/01/73350ae3-5911-3e7d-b16f-8c47a76c8d84.jpg";}','sales'=>'12','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'1','brandid'=>'1','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-02-01 16:27:32','update_time'=>'2024-02-01 16:27:32']);
        $this->insert('{{%diandi_place_list}}',['id'=>'111','bloc_id'=>'98','store_id'=>'296','name'=>'南京馨悦芸网络科技公寓','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'3','address'=>'南京喆通汽车销售有限公司','province'=>'820','city'=>'821','county'=>'830','apartment_type'=>NULL,'roomcount'=>'1','status'=>'1','phone'=>'','mail'=>'1','thumb'=>'202402/01/8f62820e-1c9f-3965-8fc1-f9115c36aede.jpg','description'=>'','content'=>'','traffic'=>'1','thumbs'=>'a:2:{i:0;s:50:"202402/01/c48153e2-8155-35cf-b935-622796717acc.jpg";i:1;s:50:"202402/01/a032079d-04e1-394c-9f6e-4505a4018aa3.jpg";}','sales'=>'1','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'1','brandid'=>'1','language'=>'0','landlord_id'=>'0','price'=>'5000.00','lease_type'=>'1','time_length'=>'3','create_time'=>'2024-02-01 17:16:43','update_time'=>'2024-02-21 10:14:07']);
        $this->insert('{{%diandi_place_list}}',['id'=>'112','bloc_id'=>'98','store_id'=>'297','name'=>'南京酒店测试','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'复兴路20号院','province'=>'801','city'=>'802','county'=>'813','apartment_type'=>NULL,'roomcount'=>'1','status'=>'1','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202402/02/96b13317-6ecd-3fad-9cee-9a172e849101.png','description'=>NULL,'content'=>NULL,'traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/02/a825e441-bae1-3c08-91eb-6da3321522be.png";}','sales'=>'1','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'122.00','lease_type'=>'0','time_length'=>'1','create_time'=>'2024-02-02 19:51:43','update_time'=>'2024-02-02 19:51:43']);
        $this->insert('{{%diandi_place_list}}',['id'=>'113','bloc_id'=>'98','store_id'=>'298','name'=>'南民宿测试','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'2','address'=>'星河苑2号院','province'=>'1','city'=>'2','county'=>'3','apartment_type'=>NULL,'roomcount'=>'1','status'=>'1','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202402/02/d5cb028f-0080-3b0e-bdbc-df7f7f4bd56c.png','description'=>'','content'=>'','traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/02/5df7b294-5aea-30ea-9160-cc1907262cde.png";}','sales'=>'1','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'2000.00','lease_type'=>'0','time_length'=>'3','create_time'=>'2024-02-02 20:35:47','update_time'=>'2024-02-05 12:52:26']);
        $this->insert('{{%diandi_place_list}}',['id'=>'114','bloc_id'=>'106','store_id'=>'299','name'=>'河北客户','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'3','address'=>'1+1大厦(彩和坊路)','province'=>'2898','city'=>'2931','county'=>'2935','apartment_type'=>NULL,'roomcount'=>'1','status'=>'1','phone'=>'','mail'=>'1','thumb'=>'202402/05/13fff116-cba6-36d4-a4aa-f584bb71e046.png','description'=>'','content'=>'','traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/05/2e5f0b96-6bf9-32b3-ad64-1d037f95cdaf.png";}','sales'=>'2','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'21','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'100.00','lease_type'=>'2','time_length'=>'3','create_time'=>'2024-02-05 19:05:10','update_time'=>'2024-02-10 19:17:36']);
        $this->insert('{{%diandi_place_list}}',['id'=>'115','bloc_id'=>'107','store_id'=>'300','name'=>'Andata','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'海淀区二马连洼菊园','province'=>'1','city'=>'2','county'=>'3','apartment_type'=>NULL,'roomcount'=>'12','status'=>'1','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202402/07/79b40215-a1d5-38d8-8484-cca7c3db7e8f.png','description'=>'','content'=>'','traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/07/4cd74790-8158-3aea-a5b4-008229de905b.png";}','sales'=>'1','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'2','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'489.00','lease_type'=>'1','time_length'=>'2','create_time'=>'2024-02-07 16:55:42','update_time'=>'2024-02-16 10:45:21']);
        $this->insert('{{%diandi_place_list}}',['id'=>'116','bloc_id'=>'38','store_id'=>'302','name'=>'店滴云酒店演示','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'钟楼','province'=>'2898','city'=>'2899','county'=>'2907','apartment_type'=>NULL,'roomcount'=>'2','status'=>'1','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202402/16/4e0de8d1-dd24-3d7e-828f-c21baf3c56d4.jpg','description'=>NULL,'content'=>NULL,'traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/16/998c821a-ac17-3b76-b2db-3bb5b96c207e.jpg";}','sales'=>'22','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'1','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'500.00','lease_type'=>'1','time_length'=>'2','create_time'=>'2024-02-16 17:30:44','update_time'=>'2024-02-16 17:30:44']);
        $this->insert('{{%diandi_place_list}}',['id'=>'117','bloc_id'=>'114','store_id'=>'303','name'=>'店滴茶室','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'5','address'=>'钟鼓楼广场(钟楼湾胡同)','province'=>'2898','city'=>'2899','county'=>'2907','apartment_type'=>NULL,'roomcount'=>'2','status'=>'0','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202402/19/6dac9014-54e0-33e7-a2e3-82c1a2d3a378.png','description'=>'','content'=>'','traffic'=>'','thumbs'=>'a:1:{i:0;s:50:"202402/19/ba31d77f-ef55-317f-bcbe-2cbd9b420331.png";}','sales'=>'1','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'2','device'=>'','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'200.00','lease_type'=>'1','time_length'=>'1','create_time'=>'2024-02-19 08:55:29','update_time'=>'2024-02-19 09:59:17']);
        $this->insert('{{%diandi_place_list}}',['id'=>'118','bloc_id'=>'115','store_id'=>'304','name'=>'doynov','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'北京市丰台区第二中学','province'=>'3022','city'=>'3023','county'=>'3025','apartment_type'=>NULL,'roomcount'=>'2','status'=>'1','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202402/19/6d3adce1-9e0a-3bc1-9136-5d81749373bc.png','description'=>NULL,'content'=>NULL,'traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/19/e9cd66cc-49f2-3c19-ae63-815841c68e75.png";}','sales'=>'1','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'433.00','lease_type'=>'1','time_length'=>'2','create_time'=>'2024-02-19 19:46:41','update_time'=>'2024-02-19 19:46:41']);
        $this->insert('{{%diandi_place_list}}',['id'=>'120','bloc_id'=>'111','store_id'=>'306','name'=>'李悦的酒店','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'12星座','province'=>'801','city'=>'802','county'=>'813','apartment_type'=>'0','roomcount'=>'1','status'=>'1','phone'=>'','mail'=>'4','thumb'=>'202402/26/db066a23-1f6e-3aa6-9cb2-a491eca85ada.png','description'=>NULL,'content'=>NULL,'traffic'=>'1','thumbs'=>'a:1:{i:0;s:50:"202402/26/4be8dc71-55a6-3ce7-b375-060a1dfa637a.png";}','sales'=>'54','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'123','device'=>'2','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'11.00','lease_type'=>'1','time_length'=>'4','create_time'=>'2024-02-26 09:57:38','update_time'=>'2024-02-26 09:57:38']);
        $this->insert('{{%diandi_place_list}}',['id'=>'121','bloc_id'=>'141','store_id'=>'307','name'=>'途观','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'富士康三期','province'=>'2670','city'=>'2741','county'=>'2742','apartment_type'=>'0','roomcount'=>'2','status'=>'1','phone'=>'','mail'=>'2192138785@qq.com','thumb'=>'202403/04/2715b13e-8129-3487-9f7b-95b7523b8026.jpg','description'=>NULL,'content'=>NULL,'traffic'=>'期望','thumbs'=>'a:1:{i:0;s:50:"202403/04/a9146d26-d2e1-3386-931a-5e45362cf207.jpg";}','sales'=>'2','displayorder'=>'1','comment_num'=>'0','comment_start'=>NULL,'level'=>'1','device'=>'2','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'400.00','lease_type'=>'1','time_length'=>'2','create_time'=>'2024-03-04 16:10:37','update_time'=>'2024-03-04 16:10:37']);
        $this->insert('{{%diandi_place_list}}',['id'=>'122','bloc_id'=>'144','store_id'=>'309','name'=>'5555','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'6','address'=>'','province'=>'801','city'=>'802','county'=>'813','apartment_type'=>'0','roomcount'=>'0','status'=>'1','phone'=>'','mail'=>'','thumb'=>'','description'=>'','content'=>'','traffic'=>'','thumbs'=>'a:0:{}','sales'=>'','displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>'','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>'10.00','lease_type'=>'1','time_length'=>'1','create_time'=>'2024-03-21 12:07:27','update_time'=>'2024-03-21 12:16:12']);
        $this->insert('{{%diandi_place_list}}',['id'=>'123','bloc_id'=>'97','store_id'=>'291','name'=>'河北微畅网络科技有限公司','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'1','province'=>'37','city'=>'124','county'=>'126','apartment_type'=>'0','roomcount'=>'0','status'=>'1','phone'=>'','mail'=>'','thumb'=>'','description'=>NULL,'content'=>NULL,'traffic'=>NULL,'thumbs'=>NULL,'sales'=>NULL,'displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-03-21 12:07:27','update_time'=>'2024-03-21 12:07:27']);
        $this->insert('{{%diandi_place_list}}',['id'=>'124','bloc_id'=>'159','store_id'=>'308','name'=>'四川柏态云科技有限公司','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'5','address'=>'218路','province'=>'2367','city'=>'2446','county'=>'2449','apartment_type'=>'0','roomcount'=>'0','status'=>'1','phone'=>'','mail'=>'','thumb'=>'','description'=>'','content'=>'','traffic'=>'','thumbs'=>'a:0:{}','sales'=>'','displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>'','brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-03-21 12:07:27','update_time'=>'2024-03-28 09:06:22']);
        $this->insert('{{%diandi_place_list}}',['id'=>'125','bloc_id'=>'189','store_id'=>'310','name'=>'11111','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'','province'=>'801','city'=>'802','county'=>'818','apartment_type'=>'0','roomcount'=>'55','status'=>'1','phone'=>'','mail'=>'','thumb'=>'','description'=>NULL,'content'=>NULL,'traffic'=>NULL,'thumbs'=>'a:0:{}','sales'=>NULL,'displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'5','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-03-30 16:19:31','update_time'=>'2024-03-30 16:19:31']);
        $this->insert('{{%diandi_place_list}}',['id'=>'126','bloc_id'=>'118','store_id'=>'305','name'=>'上云了吗','lng'=>NULL,'lat'=>NULL,'is_show'=>NULL,'address_show'=>NULL,'type'=>'1','address'=>'王府街32','province'=>'19','city'=>'20','county'=>'27','apartment_type'=>'0','roomcount'=>'0','status'=>'1','phone'=>'','mail'=>'','thumb'=>'','description'=>NULL,'content'=>NULL,'traffic'=>NULL,'thumbs'=>NULL,'sales'=>NULL,'displayorder'=>'0','comment_num'=>'0','comment_start'=>NULL,'level'=>'0','device'=>NULL,'brandid'=>'0','language'=>'0','landlord_id'=>'0','price'=>NULL,'lease_type'=>NULL,'time_length'=>NULL,'create_time'=>'2024-03-21 12:07:27','update_time'=>'2024-03-21 12:07:27']);
        
        /* 设置外键约束 */
        $this->execute('SET foreign_key_checks = 1;');
    }

    public function down()
    {
        $this->execute('SET foreign_key_checks = 0');
        /* 删除表 */
        $this->dropTable('{{%diandi_place_list}}');
        $this->execute('SET foreign_key_checks = 1;');
    }
}

